Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 36992 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 7.1 MiB |
| Average record size in memory | 200.0 B |
Variable types
| Text | 5 |
|---|---|
| Numeric | 6 |
| Categorical | 9 |
| DateTime | 2 |
| Boolean | 3 |
churn_risk_score is highly overall correlated with points_in_wallet | High correlation |
complaint_status is highly overall correlated with past_complaint | High correlation |
offer_application_preference is highly overall correlated with used_special_discount | High correlation |
past_complaint is highly overall correlated with complaint_status | High correlation |
points_in_wallet is highly overall correlated with churn_risk_score | High correlation |
used_special_discount is highly overall correlated with offer_application_preference | High correlation |
customer_id has unique values | Unique |
Name has unique values | Unique |
security_no has unique values | Unique |
Reproduction
| Analysis started | 2024-07-01 17:57:26.554131 |
|---|---|
| Analysis finished | 2024-07-01 17:57:50.500747 |
| Duration | 23.95 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
customer_id
Text
UNIQUE
| Distinct | 36992 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 35.271734 |
| Min length | 20 |
Characters and Unicode
| Total characters | 1304772 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 36992 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | fffe4300490044003600300030003800 |
|---|---|
| 2nd row | fffe43004900440032003100300035003700 |
| 3rd row | fffe4300490044003100390032003600 |
| 4th row | fffe43004900440036003000330031003600 |
| 5th row | fffe43004900440031003900350030003600 |
| Value | Count | Frequency (%) |
| fffe4300490044003600300030003800 | 1 | < 0.1% |
| fffe43004900440033003700330038003900 | 1 | < 0.1% |
| fffe43004900440032003200350033003200 | 1 | < 0.1% |
| fffe43004900440033003300330032003200 | 1 | < 0.1% |
| fffe4300490044003100390032003600 | 1 | < 0.1% |
| fffe43004900440036003000330031003600 | 1 | < 0.1% |
| fffe43004900440031003900350030003600 | 1 | < 0.1% |
| fffe43004900440036003300320035003300 | 1 | < 0.1% |
| fffe43004900440031003100360037003900 | 1 | < 0.1% |
| fffe4300490044003800300035003800 | 1 | < 0.1% |
| Other values (36982) | 36982 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 592862 | |
| 3 | 236016 | 18.1% |
| 4 | 168252 | 12.9% |
| f | 110976 | 8.5% |
| 9 | 51579 | 4.0% |
| e | 36992 | 2.8% |
| 1 | 20900 | 1.6% |
| 2 | 20831 | 1.6% |
| 5 | 20484 | 1.6% |
| 6 | 16674 | 1.3% |
| Other values (2) | 29206 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1156804 | |
| Lowercase Letter | 147968 | 11.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 592862 | |
| 3 | 236016 | 20.4% |
| 4 | 168252 | 14.5% |
| 9 | 51579 | 4.5% |
| 1 | 20900 | 1.8% |
| 2 | 20831 | 1.8% |
| 5 | 20484 | 1.8% |
| 6 | 16674 | 1.4% |
| 8 | 14641 | 1.3% |
| 7 | 14565 | 1.3% |
Lowercase Letter
| Value | Count | Frequency (%) |
| f | 110976 | |
| e | 36992 | 25.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1156804 | |
| Latin | 147968 | 11.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 592862 | |
| 3 | 236016 | 20.4% |
| 4 | 168252 | 14.5% |
| 9 | 51579 | 4.5% |
| 1 | 20900 | 1.8% |
| 2 | 20831 | 1.8% |
| 5 | 20484 | 1.8% |
| 6 | 16674 | 1.4% |
| 8 | 14641 | 1.3% |
| 7 | 14565 | 1.3% |
Latin
| Value | Count | Frequency (%) |
| f | 110976 | |
| e | 36992 | 25.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1304772 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 592862 | |
| 3 | 236016 | 18.1% |
| 4 | 168252 | 12.9% |
| f | 110976 | 8.5% |
| 9 | 51579 | 4.0% |
| e | 36992 | 2.8% |
| 1 | 20900 | 1.6% |
| 2 | 20831 | 1.6% |
| 5 | 20484 | 1.6% |
| 6 | 16674 | 1.3% |
| Other values (2) | 29206 | 2.2% |
Name
Text
UNIQUE
| Distinct | 36992 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
Length
| Max length | 24 |
|---|---|
| Median length | 21 |
| Mean length | 13.522924 |
| Min length | 6 |
Characters and Unicode
| Total characters | 500240 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 36992 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Pattie Morrisey |
|---|---|
| 2nd row | Traci Peery |
| 3rd row | Merideth Mcmeen |
| 4th row | Eufemia Cardwell |
| 5th row | Meghan Kosak |
| Value | Count | Frequency (%) |
| sidney | 137 | 0.2% |
| gilda | 126 | 0.2% |
| selena | 123 | 0.2% |
| noe | 123 | 0.2% |
| lesli | 121 | 0.2% |
| karri | 121 | 0.2% |
| marietta | 120 | 0.2% |
| kenny | 120 | 0.2% |
| earlie | 119 | 0.2% |
| dean | 119 | 0.2% |
| Other values (2511) | 72755 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 54599 | 10.9% |
| a | 50451 | 10.1% |
| 36992 | 7.4% | |
| n | 36286 | 7.3% |
| r | 34094 | 6.8% |
| i | 33029 | 6.6% |
| l | 29840 | 6.0% |
| o | 24859 | 5.0% |
| t | 17988 | 3.6% |
| s | 15985 | 3.2% |
| Other values (43) | 166117 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 389264 | |
| Uppercase Letter | 73984 | 14.8% |
| Space Separator | 36992 | 7.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 54599 | |
| a | 50451 | |
| n | 36286 | |
| r | 34094 | |
| i | 33029 | |
| l | 29840 | 7.7% |
| o | 24859 | 6.4% |
| t | 17988 | 4.6% |
| s | 15985 | 4.1% |
| d | 11744 | 3.0% |
| Other values (16) | 80389 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 7104 | 9.6% |
| M | 6774 | 9.2% |
| L | 5702 | 7.7% |
| B | 4974 | 6.7% |
| A | 4941 | 6.7% |
| C | 4690 | 6.3% |
| D | 3984 | 5.4% |
| K | 3882 | 5.2% |
| G | 3507 | 4.7% |
| R | 3447 | 4.7% |
| Other values (16) | 24979 |
Space Separator
| Value | Count | Frequency (%) |
| 36992 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 463248 | |
| Common | 36992 | 7.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 54599 | 11.8% |
| a | 50451 | 10.9% |
| n | 36286 | 7.8% |
| r | 34094 | 7.4% |
| i | 33029 | 7.1% |
| l | 29840 | 6.4% |
| o | 24859 | 5.4% |
| t | 17988 | 3.9% |
| s | 15985 | 3.5% |
| d | 11744 | 2.5% |
| Other values (42) | 154373 |
Common
| Value | Count | Frequency (%) |
| 36992 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 500240 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 54599 | 10.9% |
| a | 50451 | 10.1% |
| 36992 | 7.4% | |
| n | 36286 | 7.3% |
| r | 34094 | 6.8% |
| i | 33029 | 6.6% |
| l | 29840 | 6.0% |
| o | 24859 | 5.0% |
| t | 17988 | 3.6% |
| s | 15985 | 3.2% |
| Other values (43) | 166117 |
age
Real number (ℝ)
| Distinct | 55 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.118161 |
| Minimum | 10 |
|---|---|
| Maximum | 64 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 289.1 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 23 |
| median | 37 |
| Q3 | 51 |
| 95-th percentile | 62 |
| Maximum | 64 |
| Range | 54 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 15.867412 |
|---|---|
| Coefficient of variation (CV) | 0.4274838 |
| Kurtosis | -1.1987327 |
| Mean | 37.118161 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | -0.0073193193 |
| Sum | 1373075 |
| Variance | 251.77477 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 33 | 720 | 1.9% |
| 42 | 716 | 1.9% |
| 16 | 716 | 1.9% |
| 38 | 714 | 1.9% |
| 30 | 711 | 1.9% |
| 61 | 709 | 1.9% |
| 60 | 704 | 1.9% |
| 57 | 704 | 1.9% |
| 41 | 699 | 1.9% |
| 59 | 696 | 1.9% |
| Other values (45) | 29903 |
| Value | Count | Frequency (%) |
| 10 | 670 | |
| 11 | 654 | |
| 12 | 661 | |
| 13 | 654 | |
| 14 | 670 | |
| 15 | 649 | |
| 16 | 716 | |
| 17 | 683 | |
| 18 | 629 | |
| 19 | 660 |
| Value | Count | Frequency (%) |
| 64 | 672 | |
| 63 | 656 | |
| 62 | 677 | |
| 61 | 709 | |
| 60 | 704 | |
| 59 | 696 | |
| 58 | 678 | |
| 57 | 704 | |
| 56 | 682 | |
| 55 | 695 |
gender
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
| F | |
|---|---|
| M | |
| Unknown | 59 |
Length
| Max length | 7 |
|---|---|
| Median length | 1 |
| Mean length | 1.0095696 |
| Min length | 1 |
Characters and Unicode
| Total characters | 37346 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | F |
|---|---|
| 2nd row | F |
| 3rd row | F |
| 4th row | M |
| 5th row | F |
Common Values
| Value | Count | Frequency (%) |
| F | 18490 | |
| M | 18443 | |
| Unknown | 59 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| f | 18490 | |
| m | 18443 | |
| unknown | 59 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 18490 | |
| M | 18443 | |
| n | 177 | 0.5% |
| U | 59 | 0.2% |
| k | 59 | 0.2% |
| o | 59 | 0.2% |
| w | 59 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 36992 | |
| Lowercase Letter | 354 | 0.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 177 | |
| k | 59 | 16.7% |
| o | 59 | 16.7% |
| w | 59 | 16.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 18490 | |
| M | 18443 | |
| U | 59 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 37346 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 18490 | |
| M | 18443 | |
| n | 177 | 0.5% |
| U | 59 | 0.2% |
| k | 59 | 0.2% |
| o | 59 | 0.2% |
| w | 59 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 37346 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| F | 18490 | |
| M | 18443 | |
| n | 177 | 0.5% |
| U | 59 | 0.2% |
| k | 59 | 0.2% |
| o | 59 | 0.2% |
| w | 59 | 0.2% |
security_no
Text
UNIQUE
| Distinct | 36992 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 258944 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 36992 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | XW0DQ7H |
|---|---|
| 2nd row | 5K0N3X1 |
| 3rd row | 1F2TCL3 |
| 4th row | VJGJ33N |
| 5th row | SVZXCWB |
| Value | Count | Frequency (%) |
| xw0dq7h | 1 | < 0.1% |
| 6rz86vw | 1 | < 0.1% |
| c229qzz | 1 | < 0.1% |
| 0481qnq | 1 | < 0.1% |
| 1f2tcl3 | 1 | < 0.1% |
| vjgj33n | 1 | < 0.1% |
| svzxcwb | 1 | < 0.1% |
| psg1lgf | 1 | < 0.1% |
| r3cx1ea | 1 | < 0.1% |
| 4uj1551 | 1 | < 0.1% |
| Other values (36982) | 36982 |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 7410 | 2.9% |
| D | 7391 | 2.9% |
| H | 7346 | 2.8% |
| Z | 7307 | 2.8% |
| A | 7294 | 2.8% |
| T | 7270 | 2.8% |
| F | 7262 | 2.8% |
| R | 7249 | 2.8% |
| M | 7248 | 2.8% |
| 5 | 7244 | 2.8% |
| Other values (26) | 185923 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 187293 | |
| Decimal Number | 71651 | 27.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 7410 | 4.0% |
| D | 7391 | 3.9% |
| H | 7346 | 3.9% |
| Z | 7307 | 3.9% |
| A | 7294 | 3.9% |
| T | 7270 | 3.9% |
| F | 7262 | 3.9% |
| R | 7249 | 3.9% |
| M | 7248 | 3.9% |
| O | 7229 | 3.9% |
| Other values (16) | 114287 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 7244 | |
| 2 | 7236 | |
| 7 | 7220 | |
| 8 | 7213 | |
| 9 | 7171 | |
| 4 | 7171 | |
| 1 | 7163 | |
| 0 | 7157 | |
| 3 | 7043 | |
| 6 | 7033 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 187293 | |
| Common | 71651 | 27.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 7410 | 4.0% |
| D | 7391 | 3.9% |
| H | 7346 | 3.9% |
| Z | 7307 | 3.9% |
| A | 7294 | 3.9% |
| T | 7270 | 3.9% |
| F | 7262 | 3.9% |
| R | 7249 | 3.9% |
| M | 7248 | 3.9% |
| O | 7229 | 3.9% |
| Other values (16) | 114287 |
Common
| Value | Count | Frequency (%) |
| 5 | 7244 | |
| 2 | 7236 | |
| 7 | 7220 | |
| 8 | 7213 | |
| 9 | 7171 | |
| 4 | 7171 | |
| 1 | 7163 | |
| 0 | 7157 | |
| 3 | 7043 | |
| 6 | 7033 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 258944 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| G | 7410 | 2.9% |
| D | 7391 | 2.9% |
| H | 7346 | 2.8% |
| Z | 7307 | 2.8% |
| A | 7294 | 2.8% |
| T | 7270 | 2.8% |
| F | 7262 | 2.8% |
| R | 7249 | 2.8% |
| M | 7248 | 2.8% |
| 5 | 7244 | 2.8% |
| Other values (26) | 185923 |
region_category
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
| Town | |
|---|---|
| City | |
| Village |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.3810824 |
| Min length | 4 |
Characters and Unicode
| Total characters | 162065 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Village |
|---|---|
| 2nd row | City |
| 3rd row | Town |
| 4th row | City |
| 5th row | City |
Common Values
| Value | Count | Frequency (%) |
| Town | 19556 | |
| City | 12737 | |
| Village | 4699 | 12.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| town | 19556 | |
| city | 12737 | |
| village | 4699 | 12.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 19556 | |
| o | 19556 | |
| w | 19556 | |
| n | 19556 | |
| i | 17436 | |
| C | 12737 | |
| t | 12737 | |
| y | 12737 | |
| l | 9398 | |
| V | 4699 | 2.9% |
| Other values (3) | 14097 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 125073 | |
| Uppercase Letter | 36992 | 22.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 19556 | |
| w | 19556 | |
| n | 19556 | |
| i | 17436 | |
| t | 12737 | |
| y | 12737 | |
| l | 9398 | |
| a | 4699 | 3.8% |
| g | 4699 | 3.8% |
| e | 4699 | 3.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 19556 | |
| C | 12737 | |
| V | 4699 | 12.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 162065 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 19556 | |
| o | 19556 | |
| w | 19556 | |
| n | 19556 | |
| i | 17436 | |
| C | 12737 | |
| t | 12737 | |
| y | 12737 | |
| l | 9398 | |
| V | 4699 | 2.9% |
| Other values (3) | 14097 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 162065 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 19556 | |
| o | 19556 | |
| w | 19556 | |
| n | 19556 | |
| i | 17436 | |
| C | 12737 | |
| t | 12737 | |
| y | 12737 | |
| l | 9398 | |
| V | 4699 | 2.9% |
| Other values (3) | 14097 |
membership_category
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
| Basic Membership | |
|---|---|
| No Membership | |
| Gold Membership | |
| Silver Membership | |
| Premium Membership |
Length
| Max length | 19 |
|---|---|
| Median length | 17 |
| Mean length | 15.947043 |
| Min length | 13 |
Characters and Unicode
| Total characters | 589913 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Platinum Membership |
|---|---|
| 2nd row | Premium Membership |
| 3rd row | No Membership |
| 4th row | No Membership |
| 5th row | No Membership |
Common Values
| Value | Count | Frequency (%) |
| Basic Membership | 7724 | |
| No Membership | 7692 | |
| Gold Membership | 6795 | |
| Silver Membership | 5988 | |
| Premium Membership | 4455 | |
| Platinum Membership | 4338 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| membership | 36992 | |
| basic | 7724 | 10.4% |
| no | 7692 | 10.4% |
| gold | 6795 | 9.2% |
| silver | 5988 | 8.1% |
| premium | 4455 | 6.0% |
| platinum | 4338 | 5.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 84427 | |
| i | 59497 | |
| m | 50240 | |
| r | 47435 | 8.0% |
| s | 44716 | 7.6% |
| p | 36992 | 6.3% |
| 36992 | 6.3% | |
| M | 36992 | 6.3% |
| b | 36992 | 6.3% |
| h | 36992 | 6.3% |
| Other values (14) | 118638 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 478937 | |
| Uppercase Letter | 73984 | 12.5% |
| Space Separator | 36992 | 6.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 84427 | |
| i | 59497 | |
| m | 50240 | |
| r | 47435 | |
| s | 44716 | |
| p | 36992 | |
| b | 36992 | |
| h | 36992 | |
| l | 17121 | 3.6% |
| o | 14487 | 3.0% |
| Other values (7) | 50038 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 36992 | |
| P | 8793 | 11.9% |
| B | 7724 | 10.4% |
| N | 7692 | 10.4% |
| G | 6795 | 9.2% |
| S | 5988 | 8.1% |
Space Separator
| Value | Count | Frequency (%) |
| 36992 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 552921 | |
| Common | 36992 | 6.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 84427 | |
| i | 59497 | |
| m | 50240 | |
| r | 47435 | |
| s | 44716 | |
| p | 36992 | 6.7% |
| M | 36992 | 6.7% |
| b | 36992 | 6.7% |
| h | 36992 | 6.7% |
| l | 17121 | 3.1% |
| Other values (13) | 101517 |
Common
| Value | Count | Frequency (%) |
| 36992 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 589913 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 84427 | |
| i | 59497 | |
| m | 50240 | |
| r | 47435 | 8.0% |
| s | 44716 | 7.6% |
| p | 36992 | 6.3% |
| 36992 | 6.3% | |
| M | 36992 | 6.3% |
| b | 36992 | 6.3% |
| h | 36992 | 6.3% |
| Other values (14) | 118638 |
joining_date
Date
| Distinct | 1096 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
| Minimum | 2015-01-01 00:00:00 |
|---|---|
| Maximum | 2017-12-31 00:00:00 |
Histogram with fixed size bins (bins=50)
joined_through_referral
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
| No | |
|---|---|
| Yes | |
| ? |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.2778168 |
| Min length | 1 |
Characters and Unicode
| Total characters | 84261 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No |
|---|---|
| 2nd row | ? |
| 3rd row | Yes |
| 4th row | Yes |
| 5th row | No |
Common Values
| Value | Count | Frequency (%) |
| No | 15839 | |
| Yes | 15715 | |
| ? | 5438 | 14.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 15839 | |
| yes | 15715 | |
| 5438 | 14.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 15839 | |
| o | 15839 | |
| Y | 15715 | |
| e | 15715 | |
| s | 15715 | |
| ? | 5438 | 6.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 47269 | |
| Uppercase Letter | 31554 | |
| Other Punctuation | 5438 | 6.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 15839 | |
| e | 15715 | |
| s | 15715 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 15839 | |
| Y | 15715 |
Other Punctuation
| Value | Count | Frequency (%) |
| ? | 5438 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 78823 | |
| Common | 5438 | 6.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 15839 | |
| o | 15839 | |
| Y | 15715 | |
| e | 15715 | |
| s | 15715 |
Common
| Value | Count | Frequency (%) |
| ? | 5438 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 84261 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 15839 | |
| o | 15839 | |
| Y | 15715 | |
| e | 15715 | |
| s | 15715 | |
| ? | 5438 | 6.5% |
referral_id
Text
| Distinct | 11359 |
|---|---|
| Distinct (%) | 30.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 7.9114944 |
| Min length | 4 |
Characters and Unicode
| Total characters | 292662 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 6801 ? |
|---|---|
| Unique (%) | 18.4% |
Sample
| 1st row | xxxxxxxx |
|---|---|
| 2nd row | CID21329 |
| 3rd row | CID12313 |
| 4th row | CID3793 |
| 5th row | xxxxxxxx |
| Value | Count | Frequency (%) |
| xxxxxxxx | 17846 | |
| cid43705 | 12 | < 0.1% |
| cid3979 | 11 | < 0.1% |
| cid49601 | 10 | < 0.1% |
| cid15792 | 9 | < 0.1% |
| cid23978 | 9 | < 0.1% |
| cid40797 | 9 | < 0.1% |
| cid49598 | 9 | < 0.1% |
| cid62015 | 9 | < 0.1% |
| cid43428 | 8 | < 0.1% |
| Other values (11350) | 19065 |
Most occurring characters
| Value | Count | Frequency (%) |
| x | 142768 | |
| C | 19141 | 6.5% |
| I | 19141 | 6.5% |
| D | 19141 | 6.5% |
| 1 | 10838 | 3.7% |
| 2 | 10822 | 3.7% |
| 3 | 10766 | 3.7% |
| 5 | 10537 | 3.6% |
| 4 | 10515 | 3.6% |
| 6 | 8761 | 3.0% |
| Other values (12) | 30232 | 10.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 142813 | |
| Decimal Number | 92416 | |
| Uppercase Letter | 57428 | |
| Space Separator | 5 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 10838 | |
| 2 | 10822 | |
| 3 | 10766 | |
| 5 | 10537 | |
| 4 | 10515 | |
| 6 | 8761 | |
| 0 | 7591 | |
| 8 | 7559 | |
| 9 | 7550 | |
| 7 | 7477 |
Lowercase Letter
| Value | Count | Frequency (%) |
| x | 142768 | |
| r | 15 | < 0.1% |
| e | 10 | < 0.1% |
| o | 5 | < 0.1% |
| f | 5 | < 0.1% |
| a | 5 | < 0.1% |
| l | 5 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 19141 | |
| I | 19141 | |
| D | 19141 | |
| N | 5 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 200241 | |
| Common | 92421 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| x | 142768 | |
| C | 19141 | 9.6% |
| I | 19141 | 9.6% |
| D | 19141 | 9.6% |
| r | 15 | < 0.1% |
| e | 10 | < 0.1% |
| N | 5 | < 0.1% |
| o | 5 | < 0.1% |
| f | 5 | < 0.1% |
| a | 5 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| 1 | 10838 | |
| 2 | 10822 | |
| 3 | 10766 | |
| 5 | 10537 | |
| 4 | 10515 | |
| 6 | 8761 | |
| 0 | 7591 | |
| 8 | 7559 | |
| 9 | 7550 | |
| 7 | 7477 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 292662 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| x | 142768 | |
| C | 19141 | 6.5% |
| I | 19141 | 6.5% |
| D | 19141 | 6.5% |
| 1 | 10838 | 3.7% |
| 2 | 10822 | 3.7% |
| 3 | 10766 | 3.7% |
| 5 | 10537 | 3.6% |
| 4 | 10515 | 3.6% |
| 6 | 8761 | 3.0% |
| Other values (12) | 30232 | 10.3% |
preferred_offer_types
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
| Gift Vouchers/Coupons | |
|---|---|
| Credit/Debit Card Offers | |
| Without Offers |
Length
| Max length | 24 |
|---|---|
| Median length | 21 |
| Mean length | 19.709316 |
| Min length | 14 |
Characters and Unicode
| Total characters | 729087 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Gift Vouchers/Coupons |
|---|---|
| 2nd row | Gift Vouchers/Coupons |
| 3rd row | Gift Vouchers/Coupons |
| 4th row | Gift Vouchers/Coupons |
| 5th row | Credit/Debit Card Offers |
Common Values
| Value | Count | Frequency (%) |
| Gift Vouchers/Coupons | 12637 | |
| Credit/Debit Card Offers | 12274 | |
| Without Offers | 12081 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| offers | 24355 | |
| gift | 12637 | |
| vouchers/coupons | 12637 | |
| credit/debit | 12274 | |
| card | 12274 | |
| without | 12081 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 61540 | 8.4% |
| e | 61540 | 8.4% |
| f | 61347 | 8.4% |
| t | 61347 | 8.4% |
| o | 49992 | 6.9% |
| s | 49629 | 6.8% |
| 49266 | 6.8% | |
| i | 49266 | 6.8% |
| u | 37355 | 5.1% |
| C | 37185 | 5.1% |
| Other values (13) | 210620 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 543741 | |
| Uppercase Letter | 111169 | 15.2% |
| Space Separator | 49266 | 6.8% |
| Other Punctuation | 24911 | 3.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 61540 | |
| e | 61540 | |
| f | 61347 | |
| t | 61347 | |
| o | 49992 | |
| s | 49629 | |
| i | 49266 | |
| u | 37355 | |
| h | 24718 | 4.5% |
| d | 24548 | 4.5% |
| Other values (5) | 62459 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 37185 | |
| O | 24355 | |
| G | 12637 | 11.4% |
| V | 12637 | 11.4% |
| D | 12274 | 11.0% |
| W | 12081 | 10.9% |
Space Separator
| Value | Count | Frequency (%) |
| 49266 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 24911 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 654910 | |
| Common | 74177 | 10.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 61540 | 9.4% |
| e | 61540 | 9.4% |
| f | 61347 | 9.4% |
| t | 61347 | 9.4% |
| o | 49992 | 7.6% |
| s | 49629 | 7.6% |
| i | 49266 | 7.5% |
| u | 37355 | 5.7% |
| C | 37185 | 5.7% |
| h | 24718 | 3.8% |
| Other values (11) | 160991 |
Common
| Value | Count | Frequency (%) |
| 49266 | ||
| / | 24911 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 729087 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 61540 | 8.4% |
| e | 61540 | 8.4% |
| f | 61347 | 8.4% |
| t | 61347 | 8.4% |
| o | 49992 | 6.9% |
| s | 49629 | 6.8% |
| 49266 | 6.8% | |
| i | 49266 | 6.8% |
| u | 37355 | 5.1% |
| C | 37185 | 5.1% |
| Other values (13) | 210620 |
medium_of_operation
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
| Desktop | |
|---|---|
| Smartphone | |
| ? | |
| Both |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 6.941609 |
| Min length | 1 |
Characters and Unicode
| Total characters | 256784 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ? |
|---|---|
| 2nd row | Desktop |
| 3rd row | Desktop |
| 4th row | Desktop |
| 5th row | Smartphone |
Common Values
| Value | Count | Frequency (%) |
| Desktop | 13913 | |
| Smartphone | 13876 | |
| ? | 5393 | 14.6% |
| Both | 3810 | 10.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| desktop | 13913 | |
| smartphone | 13876 | |
| 5393 | 14.6% | |
| both | 3810 | 10.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 31599 | |
| o | 31599 | |
| e | 27789 | |
| p | 27789 | |
| h | 17686 | 6.9% |
| D | 13913 | 5.4% |
| s | 13913 | 5.4% |
| k | 13913 | 5.4% |
| S | 13876 | 5.4% |
| m | 13876 | 5.4% |
| Other values (5) | 50831 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 219792 | |
| Uppercase Letter | 31599 | 12.3% |
| Other Punctuation | 5393 | 2.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 31599 | |
| o | 31599 | |
| e | 27789 | |
| p | 27789 | |
| h | 17686 | |
| s | 13913 | |
| k | 13913 | |
| m | 13876 | |
| a | 13876 | |
| r | 13876 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 13913 | |
| S | 13876 | |
| B | 3810 | 12.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| ? | 5393 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 251391 | |
| Common | 5393 | 2.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 31599 | |
| o | 31599 | |
| e | 27789 | |
| p | 27789 | |
| h | 17686 | 7.0% |
| D | 13913 | 5.5% |
| s | 13913 | 5.5% |
| k | 13913 | 5.5% |
| S | 13876 | 5.5% |
| m | 13876 | 5.5% |
| Other values (4) | 45438 |
Common
| Value | Count | Frequency (%) |
| ? | 5393 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 256784 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 31599 | |
| o | 31599 | |
| e | 27789 | |
| p | 27789 | |
| h | 17686 | 6.9% |
| D | 13913 | 5.4% |
| s | 13913 | 5.4% |
| k | 13913 | 5.4% |
| S | 13876 | 5.4% |
| m | 13876 | 5.4% |
| Other values (5) | 50831 |
internet_option
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
| Wi-Fi | |
|---|---|
| Mobile_Data | |
| Fiber_Optic |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 8.9866458 |
| Min length | 5 |
Characters and Unicode
| Total characters | 332434 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Wi-Fi |
|---|---|
| 2nd row | Mobile_Data |
| 3rd row | Wi-Fi |
| 4th row | Mobile_Data |
| 5th row | Mobile_Data |
Common Values
| Value | Count | Frequency (%) |
| Wi-Fi | 12413 | |
| Mobile_Data | 12343 | |
| Fiber_Optic | 12236 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| wi-fi | 12413 | |
| mobile_data | 12343 | |
| fiber_optic | 12236 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 61641 | |
| a | 24686 | 7.4% |
| F | 24649 | 7.4% |
| e | 24579 | 7.4% |
| t | 24579 | 7.4% |
| _ | 24579 | 7.4% |
| b | 24579 | 7.4% |
| W | 12413 | 3.7% |
| - | 12413 | 3.7% |
| l | 12343 | 3.7% |
| Other values (7) | 85973 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 221458 | |
| Uppercase Letter | 73984 | 22.3% |
| Connector Punctuation | 24579 | 7.4% |
| Dash Punctuation | 12413 | 3.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 61641 | |
| a | 24686 | |
| e | 24579 | 11.1% |
| t | 24579 | 11.1% |
| b | 24579 | 11.1% |
| l | 12343 | 5.6% |
| o | 12343 | 5.6% |
| r | 12236 | 5.5% |
| p | 12236 | 5.5% |
| c | 12236 | 5.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 24649 | |
| W | 12413 | |
| D | 12343 | |
| M | 12343 | |
| O | 12236 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 24579 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12413 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 295442 | |
| Common | 36992 | 11.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 61641 | |
| a | 24686 | |
| F | 24649 | 8.3% |
| e | 24579 | 8.3% |
| t | 24579 | 8.3% |
| b | 24579 | 8.3% |
| W | 12413 | 4.2% |
| l | 12343 | 4.2% |
| o | 12343 | 4.2% |
| D | 12343 | 4.2% |
| Other values (5) | 61287 |
Common
| Value | Count | Frequency (%) |
| _ | 24579 | |
| - | 12413 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 332434 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 61641 | |
| a | 24686 | 7.4% |
| F | 24649 | 7.4% |
| e | 24579 | 7.4% |
| t | 24579 | 7.4% |
| _ | 24579 | 7.4% |
| b | 24579 | 7.4% |
| W | 12413 | 3.7% |
| - | 12413 | 3.7% |
| l | 12343 | 3.7% |
| Other values (7) | 85973 |
last_visit_time
Date
| Distinct | 30101 |
|---|---|
| Distinct (%) | 81.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
| Minimum | 2024-07-01 00:00:00 |
|---|---|
| Maximum | 2024-07-01 23:59:59 |
Histogram with fixed size bins (bins=50)
days_since_last_login
Real number (ℝ)
| Distinct | 27 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -41.915576 |
| Minimum | -999 |
|---|---|
| Maximum | 26 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1999 |
| Negative (%) | 5.4% |
| Memory size | 289.1 KiB |
Quantile statistics
| Minimum | -999 |
|---|---|
| 5-th percentile | -999 |
| Q1 | 8 |
| median | 12 |
| Q3 | 16 |
| 95-th percentile | 22 |
| Maximum | 26 |
| Range | 1025 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 228.8199 |
|---|---|
| Coefficient of variation (CV) | -5.4590661 |
| Kurtosis | 13.545985 |
| Mean | -41.915576 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -3.9413558 |
| Sum | -1550541 |
| Variance | 52358.547 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=27)
| Value | Count | Frequency (%) |
| 12 | 2380 | 6.4% |
| 13 | 2373 | 6.4% |
| 14 | 2307 | 6.2% |
| 15 | 2278 | 6.2% |
| 11 | 2262 | 6.1% |
| 10 | 2091 | 5.7% |
| 16 | 2068 | 5.6% |
| -999 | 1999 | 5.4% |
| 9 | 1863 | 5.0% |
| 17 | 1747 | 4.7% |
| Other values (17) | 15624 |
| Value | Count | Frequency (%) |
| -999 | 1999 | |
| 1 | 328 | 0.9% |
| 2 | 613 | 1.7% |
| 3 | 852 | |
| 4 | 998 | |
| 5 | 1234 | |
| 6 | 1257 | |
| 7 | 1442 | |
| 8 | 1571 | |
| 9 | 1863 |
| Value | Count | Frequency (%) |
| 26 | 82 | 0.2% |
| 25 | 203 | 0.5% |
| 24 | 471 | 1.3% |
| 23 | 727 | |
| 22 | 895 | |
| 21 | 1015 | |
| 20 | 1184 | |
| 19 | 1308 | |
| 18 | 1444 | |
| 17 | 1747 |
avg_time_spent
Real number (ℝ)
| Distinct | 25961 |
|---|---|
| Distinct (%) | 70.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 243.47233 |
| Minimum | -2814.1091 |
|---|---|
| Maximum | 3235.5785 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1719 |
| Negative (%) | 4.6% |
| Memory size | 289.1 KiB |
Quantile statistics
| Minimum | -2814.1091 |
|---|---|
| 5-th percentile | 30.15 |
| Q1 | 60.1025 |
| median | 161.765 |
| Q3 | 356.515 |
| 95-th percentile | 1031.0767 |
| Maximum | 3235.5785 |
| Range | 6049.6876 |
| Interquartile range (IQR) | 296.4125 |
Descriptive statistics
| Standard deviation | 398.28915 |
|---|---|
| Coefficient of variation (CV) | 1.6358703 |
| Kurtosis | 5.0039153 |
| Mean | 243.47233 |
| Median Absolute Deviation (MAD) | 122.88 |
| Skewness | 0.53962402 |
| Sum | 9006528.6 |
| Variance | 158634.25 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 34.1 | 21 | 0.1% |
| 34.71 | 20 | 0.1% |
| 33.68 | 20 | 0.1% |
| 34.33 | 19 | 0.1% |
| 31.49 | 18 | < 0.1% |
| 33.28 | 18 | < 0.1% |
| 32.91 | 18 | < 0.1% |
| 30.56 | 18 | < 0.1% |
| 33.71 | 18 | < 0.1% |
| 32.96 | 17 | < 0.1% |
| Other values (25951) | 36805 |
| Value | Count | Frequency (%) |
| -2814.10911 | 1 | |
| -2281.236526 | 1 | |
| -2096.580681 | 1 | |
| -2093.121606 | 1 | |
| -2034.80188 | 1 | |
| -2012.267374 | 1 | |
| -1960.479169 | 1 | |
| -1941.035419 | 1 | |
| -1918.486339 | 1 | |
| -1913.405154 | 1 |
| Value | Count | Frequency (%) |
| 3235.578521 | 1 | |
| 3040.41 | 1 | |
| 2899.66 | 1 | |
| 2861.23 | 1 | |
| 2770.56 | 1 | |
| 2766.75 | 1 | |
| 2747.89134 | 1 | |
| 2732.7 | 1 | |
| 2722.077794 | 1 | |
| 2705.756608 | 1 |
avg_transaction_value
Real number (ℝ)
| Distinct | 36894 |
|---|---|
| Distinct (%) | 99.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29271.194 |
| Minimum | 800.46 |
|---|---|
| Maximum | 99914.05 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 289.1 KiB |
Quantile statistics
| Minimum | 800.46 |
|---|---|
| 5-th percentile | 3468.9665 |
| Q1 | 14177.54 |
| median | 27554.485 |
| Q3 | 40855.11 |
| 95-th percentile | 67338.889 |
| Maximum | 99914.05 |
| Range | 99113.59 |
| Interquartile range (IQR) | 26677.57 |
Descriptive statistics
| Standard deviation | 19444.806 |
|---|---|
| Coefficient of variation (CV) | 0.66429836 |
| Kurtosis | 1.428287 |
| Mean | 29271.194 |
| Median Absolute Deviation (MAD) | 13336.775 |
| Skewness | 1.0110272 |
| Sum | 1.0828 × 109 |
| Variance | 3.7810049 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 14176.97 | 2 | < 0.1% |
| 7282.58 | 2 | < 0.1% |
| 30126.02 | 2 | < 0.1% |
| 21244.03 | 2 | < 0.1% |
| 23142.51 | 2 | < 0.1% |
| 35460.38 | 2 | < 0.1% |
| 9341.33 | 2 | < 0.1% |
| 34143.6 | 2 | < 0.1% |
| 3432.73 | 2 | < 0.1% |
| 6801.07 | 2 | < 0.1% |
| Other values (36884) | 36972 |
| Value | Count | Frequency (%) |
| 800.46 | 1 | |
| 804.34 | 1 | |
| 806.22 | 1 | |
| 806.71 | 1 | |
| 813.82 | 1 | |
| 815.22 | 1 | |
| 821.83 | 1 | |
| 822.7 | 1 | |
| 823.49 | 1 | |
| 823.68 | 1 |
| Value | Count | Frequency (%) |
| 99914.05 | 1 | |
| 99861.47 | 1 | |
| 99858.02 | 1 | |
| 99819.19 | 1 | |
| 99810.83 | 1 | |
| 99805.52 | 1 | |
| 99803.53 | 1 | |
| 99795.75 | 1 | |
| 99742.63 | 1 | |
| 99730.17 | 1 |
| Distinct | 1654 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
Length
| Max length | 21 |
|---|---|
| Median length | 4 |
| Mean length | 4.494215 |
| Min length | 3 |
Characters and Unicode
| Total characters | 166250 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1623 ? |
|---|---|
| Unique (%) | 4.4% |
Sample
| 1st row | 17.0 |
|---|---|
| 2nd row | 10.0 |
| 3rd row | 22.0 |
| 4th row | 6.0 |
| 5th row | 16.0 |
| Value | Count | Frequency (%) |
| error | 3522 | 9.5% |
| 13.0 | 1394 | 3.8% |
| 19.0 | 1365 | 3.7% |
| 8.0 | 1361 | 3.7% |
| 14.0 | 1355 | 3.7% |
| 17.0 | 1349 | 3.6% |
| 6.0 | 1336 | 3.6% |
| 10.0 | 1334 | 3.6% |
| 18.0 | 1331 | 3.6% |
| 12.0 | 1327 | 3.6% |
| Other values (1644) | 21318 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 36699 | |
| . | 33470 | |
| 1 | 18719 | |
| 2 | 16061 | |
| r | 10566 | 6.4% |
| 5 | 6508 | 3.9% |
| 7 | 6331 | 3.8% |
| 6 | 6312 | 3.8% |
| 8 | 6269 | 3.8% |
| 9 | 6258 | 3.8% |
| Other values (5) | 19057 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 114487 | |
| Other Punctuation | 33470 | 20.1% |
| Lowercase Letter | 14088 | 8.5% |
| Uppercase Letter | 3522 | 2.1% |
| Dash Punctuation | 683 | 0.4% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 36699 | |
| 1 | 18719 | |
| 2 | 16061 | |
| 5 | 6508 | 5.7% |
| 7 | 6331 | 5.5% |
| 6 | 6312 | 5.5% |
| 8 | 6269 | 5.5% |
| 9 | 6258 | 5.5% |
| 3 | 5692 | 5.0% |
| 4 | 5638 | 4.9% |
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 10566 | |
| o | 3522 | 25.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 33470 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 3522 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 683 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 148640 | |
| Latin | 17610 | 10.6% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 36699 | |
| . | 33470 | |
| 1 | 18719 | |
| 2 | 16061 | |
| 5 | 6508 | 4.4% |
| 7 | 6331 | 4.3% |
| 6 | 6312 | 4.2% |
| 8 | 6269 | 4.2% |
| 9 | 6258 | 4.2% |
| 3 | 5692 | 3.8% |
| Other values (2) | 6321 | 4.3% |
Latin
| Value | Count | Frequency (%) |
| r | 10566 | |
| E | 3522 | 20.0% |
| o | 3522 | 20.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 166250 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 36699 | |
| . | 33470 | |
| 1 | 18719 | |
| 2 | 16061 | |
| r | 10566 | 6.4% |
| 5 | 6508 | 3.9% |
| 7 | 6331 | 3.8% |
| 6 | 6312 | 3.8% |
| 8 | 6269 | 3.8% |
| 9 | 6258 | 3.8% |
| Other values (5) | 19057 |
points_in_wallet
Real number (ℝ)
HIGH CORRELATION
| Distinct | 23700 |
|---|---|
| Distinct (%) | 64.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 686.8822 |
| Minimum | -760.66124 |
|---|---|
| Maximum | 2069.0698 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 136 |
| Negative (%) | 0.4% |
| Memory size | 289.1 KiB |
Quantile statistics
| Minimum | -760.66124 |
|---|---|
| 5-th percentile | 351.82615 |
| Q1 | 624.35 |
| median | 686.8822 |
| Q3 | 757.0025 |
| 95-th percentile | 1028.8753 |
| Maximum | 2069.0698 |
| Range | 2829.731 |
| Interquartile range (IQR) | 132.6525 |
Descriptive statistics
| Standard deviation | 184.81168 |
|---|---|
| Coefficient of variation (CV) | 0.26905877 |
| Kurtosis | 5.1876557 |
| Mean | 686.8822 |
| Median Absolute Deviation (MAD) | 66.652199 |
| Skewness | -0.08432911 |
| Sum | 25409146 |
| Variance | 34155.358 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 686.8821987 | 3443 | 9.3% |
| 705.07 | 9 | < 0.1% |
| 780.92 | 8 | < 0.1% |
| 771.75 | 7 | < 0.1% |
| 710.69 | 7 | < 0.1% |
| 760.54 | 7 | < 0.1% |
| 760.76 | 6 | < 0.1% |
| 719.78 | 6 | < 0.1% |
| 760.58 | 6 | < 0.1% |
| 748.98 | 6 | < 0.1% |
| Other values (23690) | 33487 |
| Value | Count | Frequency (%) |
| -760.6612363 | 1 | |
| -549.3574977 | 1 | |
| -506.2567158 | 1 | |
| -483.8564006 | 1 | |
| -471.577009 | 1 | |
| -469.0203988 | 1 | |
| -445.2884572 | 1 | |
| -424.6705248 | 1 | |
| -412.4416878 | 1 | |
| -405.2670355 | 1 |
| Value | Count | Frequency (%) |
| 2069.069761 | 1 | |
| 1816.933696 | 1 | |
| 1780.720173 | 1 | |
| 1763.351594 | 1 | |
| 1759.002532 | 1 | |
| 1755.455512 | 1 | |
| 1755.094693 | 1 | |
| 1751.304195 | 1 | |
| 1750.611562 | 1 | |
| 1736.332594 | 1 |
used_special_discount
Boolean
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 36.3 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 20342 | |
| False | 16650 |
offer_application_preference
Boolean
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 36.3 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 20440 | |
| False | 16552 |
past_complaint
Boolean
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 36.3 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 18602 | |
| True | 18390 |
complaint_status
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
| Not Applicable | |
|---|---|
| Unsolved | |
| Solved | |
| Solved in Follow-up | |
| No Information Available |
Length
| Max length | 24 |
|---|---|
| Median length | 14 |
| Mean length | 14.09648 |
| Min length | 6 |
Characters and Unicode
| Total characters | 521457 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Not Applicable |
|---|---|
| 2nd row | Solved |
| 3rd row | Solved in Follow-up |
| 4th row | Unsolved |
| 5th row | Solved |
Common Values
| Value | Count | Frequency (%) |
| Not Applicable | 18602 | |
| Unsolved | 4644 | 12.6% |
| Solved | 4619 | 12.5% |
| Solved in Follow-up | 4577 | 12.4% |
| No Information Available | 4550 | 12.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| not | 18602 | |
| applicable | 18602 | |
| solved | 9196 | |
| unsolved | 4644 | 6.3% |
| in | 4577 | 6.2% |
| follow-up | 4577 | 6.2% |
| no | 4550 | 6.2% |
| information | 4550 | 6.2% |
| available | 4550 | 6.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 69298 | |
| o | 55246 | 10.6% |
| p | 41781 | 8.0% |
| e | 36992 | 7.1% |
| 36856 | 7.1% | |
| i | 32279 | 6.2% |
| a | 32252 | 6.2% |
| N | 23152 | 4.4% |
| t | 23152 | 4.4% |
| A | 23152 | 4.4% |
| Other values (16) | 147297 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 410753 | |
| Uppercase Letter | 69271 | 13.3% |
| Space Separator | 36856 | 7.1% |
| Dash Punctuation | 4577 | 0.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 69298 | |
| o | 55246 | |
| p | 41781 | |
| e | 36992 | |
| i | 32279 | |
| a | 32252 | |
| t | 23152 | 5.6% |
| b | 23152 | 5.6% |
| c | 18602 | 4.5% |
| v | 18390 | 4.5% |
| Other values (8) | 59609 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 23152 | |
| A | 23152 | |
| S | 9196 | 13.3% |
| U | 4644 | 6.7% |
| F | 4577 | 6.6% |
| I | 4550 | 6.6% |
Space Separator
| Value | Count | Frequency (%) |
| 36856 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4577 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 480024 | |
| Common | 41433 | 7.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 69298 | |
| o | 55246 | |
| p | 41781 | 8.7% |
| e | 36992 | 7.7% |
| i | 32279 | 6.7% |
| a | 32252 | 6.7% |
| N | 23152 | 4.8% |
| t | 23152 | 4.8% |
| A | 23152 | 4.8% |
| b | 23152 | 4.8% |
| Other values (14) | 119568 |
Common
| Value | Count | Frequency (%) |
| 36856 | ||
| - | 4577 | 11.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 521457 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 69298 | |
| o | 55246 | 10.6% |
| p | 41781 | 8.0% |
| e | 36992 | 7.1% |
| 36856 | 7.1% | |
| i | 32279 | 6.2% |
| a | 32252 | 6.2% |
| N | 23152 | 4.4% |
| t | 23152 | 4.4% |
| A | 23152 | 4.4% |
| Other values (16) | 147297 |
feedback
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 289.1 KiB |
| Poor Product Quality | |
|---|---|
| No reason specified | |
| Too many ads | |
| Poor Website | |
| Poor Customer Service | |
| Other values (4) |
Length
| Max length | 24 |
|---|---|
| Median length | 21 |
| Mean length | 17.355455 |
| Min length | 12 |
Characters and Unicode
| Total characters | 642013 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Products always in Stock |
|---|---|
| 2nd row | Quality Customer Care |
| 3rd row | Poor Website |
| 4th row | Poor Website |
| 5th row | Poor Website |
Common Values
| Value | Count | Frequency (%) |
| Poor Product Quality | 6350 | |
| No reason specified | 6290 | |
| Too many ads | 6279 | |
| Poor Website | 6271 | |
| Poor Customer Service | 6252 | |
| Reasonable Price | 1417 | 3.8% |
| User Friendly Website | 1391 | 3.8% |
| Products always in Stock | 1382 | 3.7% |
| Quality Customer Care | 1360 | 3.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| poor | 18873 | |
| quality | 7710 | 7.4% |
| website | 7662 | 7.3% |
| customer | 7612 | 7.3% |
| product | 6350 | 6.1% |
| reason | 6290 | 6.0% |
| no | 6290 | 6.0% |
| specified | 6290 | 6.0% |
| too | 6279 | 6.0% |
| many | 6279 | 6.0% |
| Other values (11) | 25035 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 81027 | |
| 67678 | 10.5% | |
| e | 62703 | 9.8% |
| r | 52318 | 8.1% |
| s | 39705 | 6.2% |
| i | 38394 | 6.0% |
| a | 33516 | 5.2% |
| t | 32098 | 5.0% |
| P | 28022 | 4.4% |
| c | 23073 | 3.6% |
| Other values (21) | 183479 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 497567 | |
| Uppercase Letter | 76768 | 12.0% |
| Space Separator | 67678 | 10.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 81027 | |
| e | 62703 | |
| r | 52318 | |
| s | 39705 | |
| i | 38394 | |
| a | 33516 | 6.7% |
| t | 32098 | 6.5% |
| c | 23073 | 4.6% |
| u | 23054 | 4.6% |
| d | 21692 | 4.4% |
| Other values (10) | 89987 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 28022 | |
| C | 8972 | 11.7% |
| Q | 7710 | 10.0% |
| W | 7662 | 10.0% |
| S | 7634 | 9.9% |
| N | 6290 | 8.2% |
| T | 6279 | 8.2% |
| R | 1417 | 1.8% |
| U | 1391 | 1.8% |
| F | 1391 | 1.8% |
Space Separator
| Value | Count | Frequency (%) |
| 67678 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 574335 | |
| Common | 67678 | 10.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 81027 | |
| e | 62703 | 10.9% |
| r | 52318 | 9.1% |
| s | 39705 | 6.9% |
| i | 38394 | 6.7% |
| a | 33516 | 5.8% |
| t | 32098 | 5.6% |
| P | 28022 | 4.9% |
| c | 23073 | 4.0% |
| u | 23054 | 4.0% |
| Other values (20) | 160425 |
Common
| Value | Count | Frequency (%) |
| 67678 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 642013 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 81027 | |
| 67678 | 10.5% | |
| e | 62703 | 9.8% |
| r | 52318 | 8.1% |
| s | 39705 | 6.2% |
| i | 38394 | 6.0% |
| a | 33516 | 5.2% |
| t | 32098 | 5.0% |
| P | 28022 | 4.4% |
| c | 23073 | 3.6% |
| Other values (21) | 183479 |
churn_risk_score
Real number (ℝ)
HIGH CORRELATION
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4633975 |
| Minimum | -1 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1163 |
| Negative (%) | 3.1% |
| Memory size | 289.1 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 6 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.4096609 |
|---|---|
| Coefficient of variation (CV) | 0.40701679 |
| Kurtosis | 1.299243 |
| Mean | 3.4633975 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -1.1143052 |
| Sum | 128118 |
| Variance | 1.9871439 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 3 | 10424 | |
| 4 | 10185 | |
| 5 | 9827 | |
| 2 | 2741 | 7.4% |
| 1 | 2652 | 7.2% |
| -1 | 1163 | 3.1% |
| Value | Count | Frequency (%) |
| -1 | 1163 | 3.1% |
| 1 | 2652 | 7.2% |
| 2 | 2741 | 7.4% |
| 3 | 10424 | |
| 4 | 10185 | |
| 5 | 9827 |
| Value | Count | Frequency (%) |
| 5 | 9827 | |
| 4 | 10185 | |
| 3 | 10424 | |
| 2 | 2741 | 7.4% |
| 1 | 2652 | 7.2% |
| -1 | 1163 | 3.1% |
| age | avg_time_spent | avg_transaction_value | churn_risk_score | complaint_status | days_since_last_login | feedback | gender | internet_option | joined_through_referral | medium_of_operation | membership_category | offer_application_preference | past_complaint | points_in_wallet | preferred_offer_types | region_category | used_special_discount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| age | 1.000 | 0.003 | -0.001 | 0.004 | 0.000 | -0.003 | 0.006 | 0.000 | 0.014 | 0.003 | 0.008 | 0.000 | 0.000 | 0.012 | -0.001 | 0.007 | 0.000 | 0.000 |
| avg_time_spent | 0.003 | 1.000 | 0.019 | -0.029 | 0.002 | -0.100 | 0.021 | 0.000 | 0.010 | 0.088 | 0.209 | 0.004 | 0.104 | 0.000 | 0.011 | 0.007 | 0.012 | 0.113 |
| avg_transaction_value | -0.001 | 0.019 | 1.000 | -0.201 | 0.000 | -0.005 | 0.244 | 0.000 | 0.002 | 0.033 | 0.023 | 0.131 | 0.035 | 0.000 | 0.105 | 0.039 | 0.024 | 0.000 |
| churn_risk_score | 0.004 | -0.029 | -0.201 | 1.000 | 0.000 | 0.016 | 0.441 | 0.000 | 0.000 | 0.047 | 0.027 | 0.413 | 0.050 | 0.011 | -0.542 | 0.064 | 0.034 | 0.006 |
| complaint_status | 0.000 | 0.002 | 0.000 | 0.000 | 1.000 | -0.000 | 0.000 | 0.000 | 0.005 | 0.005 | 0.000 | 0.000 | 0.011 | 1.000 | -0.003 | 0.007 | 0.000 | 0.004 |
| days_since_last_login | -0.003 | -0.100 | -0.005 | 0.016 | -0.000 | 1.000 | 0.012 | 0.008 | 0.000 | 0.008 | 0.000 | 0.000 | 0.000 | 0.000 | -0.001 | 0.004 | 0.000 | 0.000 |
| feedback | 0.006 | 0.021 | 0.244 | 0.441 | 0.000 | 0.012 | 1.000 | 0.003 | 0.005 | 0.047 | 0.028 | 0.188 | 0.049 | 0.010 | 0.149 | 0.064 | 0.033 | 0.008 |
| gender | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.008 | 0.003 | 1.000 | 0.000 | 0.000 | 0.002 | 0.000 | 0.000 | 0.004 | -0.003 | 0.006 | 0.000 | 0.000 |
| internet_option | 0.014 | 0.010 | 0.002 | 0.000 | 0.005 | 0.000 | 0.005 | 0.000 | 1.000 | 0.004 | 0.000 | 0.003 | 0.000 | 0.000 | 0.004 | 0.000 | 0.000 | 0.000 |
| joined_through_referral | 0.003 | 0.088 | 0.033 | 0.047 | 0.005 | 0.008 | 0.047 | 0.000 | 0.004 | 1.000 | 0.044 | 0.022 | 0.021 | 0.000 | -0.015 | 0.000 | 0.000 | 0.019 |
| medium_of_operation | 0.008 | 0.209 | 0.023 | 0.027 | 0.000 | 0.000 | 0.028 | 0.002 | 0.000 | 0.044 | 1.000 | 0.013 | 0.049 | 0.005 | -0.007 | 0.000 | 0.000 | 0.063 |
| membership_category | 0.000 | 0.004 | 0.131 | 0.413 | 0.000 | 0.000 | 0.188 | 0.000 | 0.003 | 0.022 | 0.013 | 1.000 | 0.011 | 0.005 | 0.297 | 0.024 | 0.013 | 0.004 |
| offer_application_preference | 0.000 | 0.104 | 0.035 | 0.050 | 0.011 | 0.000 | 0.049 | 0.000 | 0.000 | 0.021 | 0.049 | 0.011 | 1.000 | 0.005 | 0.010 | 0.000 | 0.000 | 0.814 |
| past_complaint | 0.012 | 0.000 | 0.000 | 0.011 | 1.000 | 0.000 | 0.010 | 0.004 | 0.000 | 0.000 | 0.005 | 0.005 | 0.005 | 1.000 | -0.008 | 0.000 | 0.000 | 0.005 |
| points_in_wallet | -0.001 | 0.011 | 0.105 | -0.542 | -0.003 | -0.001 | 0.149 | -0.003 | 0.004 | -0.015 | -0.007 | 0.297 | 0.010 | -0.008 | 1.000 | 0.011 | 0.006 | 0.010 |
| preferred_offer_types | 0.007 | 0.007 | 0.039 | 0.064 | 0.007 | 0.004 | 0.064 | 0.006 | 0.000 | 0.000 | 0.000 | 0.024 | 0.000 | 0.000 | 0.011 | 1.000 | 0.004 | 0.000 |
| region_category | 0.000 | 0.012 | 0.024 | 0.034 | 0.000 | 0.000 | 0.033 | 0.000 | 0.000 | 0.000 | 0.000 | 0.013 | 0.000 | 0.000 | 0.006 | 0.004 | 1.000 | 0.000 |
| used_special_discount | 0.000 | 0.113 | 0.000 | 0.006 | 0.004 | 0.000 | 0.008 | 0.000 | 0.000 | 0.019 | 0.063 | 0.004 | 0.814 | 0.005 | 0.010 | 0.000 | 0.000 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| customer_id | Name | age | gender | security_no | region_category | membership_category | joining_date | joined_through_referral | referral_id | preferred_offer_types | medium_of_operation | internet_option | last_visit_time | days_since_last_login | avg_time_spent | avg_transaction_value | avg_frequency_login_days | points_in_wallet | used_special_discount | offer_application_preference | past_complaint | complaint_status | feedback | churn_risk_score | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | fffe4300490044003600300030003800 | Pattie Morrisey | 18 | F | XW0DQ7H | Village | Platinum Membership | 2017-08-17 | No | xxxxxxxx | Gift Vouchers/Coupons | ? | Wi-Fi | 16:08:02 | 17 | 300.63 | 53005.25 | 17.0 | 781.750000 | Yes | Yes | No | Not Applicable | Products always in Stock | 2 |
| 1 | fffe43004900440032003100300035003700 | Traci Peery | 32 | F | 5K0N3X1 | City | Premium Membership | 2017-08-28 | ? | CID21329 | Gift Vouchers/Coupons | Desktop | Mobile_Data | 12:38:13 | 16 | 306.34 | 12838.38 | 10.0 | 686.882199 | Yes | No | Yes | Solved | Quality Customer Care | 1 |
| 2 | fffe4300490044003100390032003600 | Merideth Mcmeen | 44 | F | 1F2TCL3 | Town | No Membership | 2016-11-11 | Yes | CID12313 | Gift Vouchers/Coupons | Desktop | Wi-Fi | 22:53:21 | 14 | 516.16 | 21027.00 | 22.0 | 500.690000 | No | Yes | Yes | Solved in Follow-up | Poor Website | 5 |
| 3 | fffe43004900440036003000330031003600 | Eufemia Cardwell | 37 | M | VJGJ33N | City | No Membership | 2016-10-29 | Yes | CID3793 | Gift Vouchers/Coupons | Desktop | Mobile_Data | 15:57:50 | 11 | 53.27 | 25239.56 | 6.0 | 567.660000 | No | Yes | Yes | Unsolved | Poor Website | 5 |
| 4 | fffe43004900440031003900350030003600 | Meghan Kosak | 31 | F | SVZXCWB | City | No Membership | 2017-09-12 | No | xxxxxxxx | Credit/Debit Card Offers | Smartphone | Mobile_Data | 15:46:44 | 20 | 113.13 | 24483.66 | 16.0 | 663.060000 | No | Yes | Yes | Solved | Poor Website | 5 |
| 5 | fffe43004900440036003300320035003300 | Leslie Browder | 13 | M | PSG1LGF | City | Gold Membership | 2016-01-08 | No | xxxxxxxx | Gift Vouchers/Coupons | ? | Wi-Fi | 06:46:07 | 23 | 433.62 | 13884.77 | 24.0 | 722.270000 | Yes | No | Yes | Unsolved | No reason specified | 3 |
| 6 | fffe43004900440031003100360037003900 | Bridget Balog | 21 | M | R3CX1EA | Town | Gold Membership | 2015-03-19 | Yes | CID24708 | Gift Vouchers/Coupons | Desktop | Mobile_Data | 11:40:04 | 10 | 55.38 | 8982.50 | 28.0 | 756.210000 | Yes | No | Yes | Solved in Follow-up | No reason specified | 3 |
| 7 | fffe4300490044003800300035003800 | Herma Torgeson | 42 | M | 4UJ1551 | Town | No Membership | 2016-07-12 | ? | CID56614 | Credit/Debit Card Offers | Both | Fiber_Optic | 07:52:43 | 19 | 429.11 | 44554.82 | 24.0 | 568.080000 | No | Yes | Yes | Unsolved | Poor Product Quality | 5 |
| 8 | fffe43004900440033003300330032003200 | Pattie Helmers | 44 | M | 0481QNQ | Village | Silver Membership | 2016-12-14 | No | xxxxxxxx | Without Offers | Smartphone | Fiber_Optic | 06:50:10 | 15 | 191.07 | 18362.31 | 20.0 | 686.882199 | Yes | No | Yes | Solved in Follow-up | Poor Customer Service | 3 |
| 9 | fffe43004900440032003000340038003300 | Shaquana Leech | 45 | F | ZHP4MCR | Town | No Membership | 2016-11-30 | No | xxxxxxxx | Gift Vouchers/Coupons | ? | Wi-Fi | 19:10:16 | 10 | 97.31 | 19244.16 | 28.0 | 706.230000 | No | Yes | Yes | No Information Available | Poor Customer Service | 4 |
| customer_id | Name | age | gender | security_no | region_category | membership_category | joining_date | joined_through_referral | referral_id | preferred_offer_types | medium_of_operation | internet_option | last_visit_time | days_since_last_login | avg_time_spent | avg_transaction_value | avg_frequency_login_days | points_in_wallet | used_special_discount | offer_application_preference | past_complaint | complaint_status | feedback | churn_risk_score | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36982 | fffe43004900440033003600330033003800 | Leslie Bruneau | 45 | F | I2TAL7N | Town | Premium Membership | 2016-08-31 | No | xxxxxxxx | Gift Vouchers/Coupons | ? | Wi-Fi | 08:30:41 | 10 | 34.930000 | 41558.93 | 19.0 | 703.030000 | Yes | No | No | Not Applicable | Poor Product Quality | 3 |
| 36983 | fffe43004900440032003300370030003700 | Faustina Balog | 45 | M | PU0XLQY | Town | Basic Membership | 2016-08-30 | Yes | CID45477 | Without Offers | Smartphone | Wi-Fi | 10:53:31 | 9 | 49.330000 | 45358.49 | 11.0 | 242.979625 | Yes | No | No | Not Applicable | Poor Customer Service | 5 |
| 36984 | fffe43004900440035003800320035003300 | Hilary Ortego | 51 | M | LM92BDS | Town | Gold Membership | 2016-10-07 | No | xxxxxxxx | Without Offers | Desktop | Fiber_Optic | 15:41:36 | 24 | 312.330000 | 63446.71 | 2.0 | 778.700000 | No | Yes | No | Not Applicable | Products always in Stock | 1 |
| 36985 | fffe4300490044003800310034003500 | Dwain Cann | 12 | F | GWAHGJY | Village | Premium Membership | 2016-10-25 | No | xxxxxxxx | Gift Vouchers/Coupons | Desktop | Fiber_Optic | 03:30:17 | 13 | 418.380000 | 56397.21 | 7.0 | 725.890000 | Yes | Yes | Yes | Unsolved | Products always in Stock | 2 |
| 36986 | fffe43004900440034003900300036003500 | Marlena Chastain | 27 | M | 8X0LUUS | Town | Platinum Membership | 2015-09-07 | Yes | CID15800 | Credit/Debit Card Offers | Desktop | Mobile_Data | 05:29:19 | 13 | 135.830000 | 8225.68 | 16.0 | 748.570000 | Yes | No | No | Not Applicable | No reason specified | 3 |
| 36987 | fffe43004900440035003500390036003100 | Cuc Tarr | 46 | F | 6F51HFO | Town | Basic Membership | 2017-09-21 | No | xxxxxxxx | Credit/Debit Card Offers | Desktop | Wi-Fi | 04:14:05 | 2 | -650.682759 | 27277.68 | 6.0 | 639.510000 | No | Yes | Yes | No Information Available | No reason specified | 4 |
| 36988 | fffe43004900440033003500380036003600 | Jenni Stronach | 29 | F | 21KSM8Y | Town | Basic Membership | 2016-06-27 | No | xxxxxxxx | Without Offers | Smartphone | Wi-Fi | 23:18:31 | 13 | -638.123421 | 11069.71 | 28.0 | 527.990000 | Yes | No | No | Not Applicable | Poor Customer Service | 5 |
| 36989 | fffe4300490044003500330034003100 | Luciana Kinch | 23 | F | XK1IM9H | Town | Basic Membership | 2016-09-11 | Yes | CID3838 | Gift Vouchers/Coupons | Desktop | Wi-Fi | 03:50:25 | 12 | 154.940000 | 38127.56 | Error | 680.470000 | No | Yes | Yes | Unsolved | Poor Website | 4 |
| 36990 | fffe43004900440031003200390039003000 | Tawana Ardoin | 53 | M | K6VTP1Z | Village | Platinum Membership | 2017-06-15 | No | xxxxxxxx | Gift Vouchers/Coupons | Smartphone | Mobile_Data | 09:50:03 | 15 | 482.610000 | 2378.86 | 20.0 | 197.264414 | Yes | Yes | No | Not Applicable | No reason specified | 3 |
| 36991 | fffe43004900440033003600340034003200 | Verlene Beaulieu | 35 | M | LBX0GLR | Town | Silver Membership | 2015-10-23 | No | xxxxxxxx | Gift Vouchers/Coupons | Desktop | Mobile_Data | 01:39:52 | 15 | 79.180000 | 2189.68 | Error | 719.970000 | Yes | No | No | Not Applicable | Quality Customer Care | 2 |